<!DOCTYPE html>
<html lang="en-US">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Table Data | Luckysheet Document</title>
    <meta name="generator" content="VuePress 1.8.0">
    
    <meta name="description" content="Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.This site contains official configuration document, API, and tutorial.">
    <meta property="article:modified_time" content="2021-01-19T01:33:53.000Z">
    <meta property="og:title" content="Table Data">
    <meta property="og:type" content="article">
    <meta property="og:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/data.html">
    <meta name="twitter:title" content="Table Data">
    <meta name="twitter:url" content="https://mengshukeji.github.io/LuckysheetDemo/guide/data.html">
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:label1" content="Written by">
    
    <link rel="preload" href="/LuckysheetDocs/assets/css/0.styles.58462003.css" as="style"><link rel="preload" href="/LuckysheetDocs/assets/js/app.02d9598d.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/2.daa13025.js" as="script"><link rel="preload" href="/LuckysheetDocs/assets/js/17.e9ae302c.js" as="script"><link rel="prefetch" href="/LuckysheetDocs/assets/js/10.866635ea.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/11.825eabba.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/12.980dcb91.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/13.119fa3a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/14.61ea2478.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/15.51a43d85.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/16.de626d16.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/18.46d5e5a0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/19.6ab6bd88.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/20.a4dd0048.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/21.cf5034d8.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/22.c45a4387.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/23.e08fd533.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/24.d1e4369b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/25.291afc50.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/26.e74f90a6.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/27.1142ecb7.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/28.d6d28da0.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/29.1ae5f953.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/3.c428902d.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/30.bf70d4f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/31.d87cf3af.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/32.a1b6f5f4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/33.eded6080.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/4.b5e0f872.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/5.e526f9d4.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/6.8106d72b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/7.c0fe87fd.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/8.abc5c19b.js"><link rel="prefetch" href="/LuckysheetDocs/assets/js/9.2bf3882a.js">
    <link rel="stylesheet" href="/LuckysheetDocs/assets/css/0.styles.58462003.css">
  </head>
  <body>
    <div id="app" data-server-rendered="true"><div class="theme-container"><header class="navbar"><div class="sidebar-button"><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" role="img" viewBox="0 0 448 512" class="icon"><path fill="currentColor" d="M436 124H12c-6.627 0-12-5.373-12-12V80c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12zm0 160H12c-6.627 0-12-5.373-12-12v-32c0-6.627 5.373-12 12-12h424c6.627 0 12 5.373 12 12v32c0 6.627-5.373 12-12 12z"></path></svg></div> <a href="/LuckysheetDocs/" class="home-link router-link-active"><img src="/LuckysheetDocs/img/logo.png" alt="Luckysheet Document" class="logo"> <span class="site-name can-hide">Luckysheet Document</span></a> <div class="links"><div class="search-box"><input aria-label="Search" autocomplete="off" spellcheck="false" value=""> <!----></div> <nav class="nav-links can-hide"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" class="nav-link router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/data.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav></div></header> <div class="sidebar-mask"></div> <aside class="sidebar"><nav class="nav-links"><div class="nav-item"><a href="/LuckysheetDocs/" class="nav-link">
  Home
</a></div><div class="nav-item"><a href="/LuckysheetDocs/guide/" class="nav-link router-link-active">
  Guide
</a></div><div class="nav-item"><a href="https://mengshukeji.github.io/LuckysheetDemo/" target="_blank" rel="noopener noreferrer" class="nav-link external">
  Demo
  <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="More" class="dropdown-title"><span class="title">More</span> <span class="arrow down"></span></button> <button type="button" aria-label="More" class="mobile-dropdown-title"><span class="title">More</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/about/" class="nav-link">
  About
</a></li></ul></div></div><div class="nav-item"><div class="dropdown-wrapper"><button type="button" aria-label="Select language" class="dropdown-title"><span class="title">Languages</span> <span class="arrow down"></span></button> <button type="button" aria-label="Select language" class="mobile-dropdown-title"><span class="title">Languages</span> <span class="arrow right"></span></button> <ul class="nav-dropdown" style="display:none;"><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/guide/data.html" aria-current="page" class="nav-link router-link-exact-active router-link-active">
  English
</a></li><li class="dropdown-item"><!----> <a href="/LuckysheetDocs/zh/" class="nav-link">
  简体中文
</a></li></ul></div></div> <a href="https://github.com/mengshukeji/Luckysheet" target="_blank" rel="noopener noreferrer" class="repo-link">
    GitHub
    <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></a></nav>  <ul class="sidebar-links"><li><a href="/LuckysheetDocs/guide/" aria-current="page" class="sidebar-link">Get started</a></li><li><a href="/LuckysheetDocs/guide/config.html" class="sidebar-link">Overall configuration</a></li><li><a href="/LuckysheetDocs/guide/sheet.html" class="sidebar-link">Sheet Configuration</a></li><li><a href="/LuckysheetDocs/guide/cell.html" class="sidebar-link">Format attributes</a></li><li><a href="/LuckysheetDocs/guide/operate.html" class="sidebar-link">Table Operation</a></li><li><a href="/LuckysheetDocs/guide/api.html" class="sidebar-link">API</a></li><li><a href="/LuckysheetDocs/guide/resource.html" class="sidebar-link">Tutorials and resources</a></li><li><a href="/LuckysheetDocs/guide/FAQ.html" class="sidebar-link">FAQ</a></li><li><a href="/LuckysheetDocs/guide/contribute.html" class="sidebar-link">Contribution guide</a></li></ul> </aside> <main class="page"> <div class="theme-default-content content__default"><h1 id="table-data"><a href="#table-data" class="header-anchor">#</a> Table Data</h1> <h2 id="get-table-data"><a href="#get-table-data" class="header-anchor">#</a> Get table data</h2> <ul><li><p><strong>Configuration</strong>：</p> <p>Configure the address of <code>updateUrl</code>, Luckysheet will request the table data through ajax. By default, all <code>data</code> in the sheet data with status 1 is loaded, and the rest of the sheet loads all fields except the <code>data</code> field.</p></li> <li><p><strong>Format</strong>：
Through the global method <code>luckysheet.getluckysheetfile()</code>, the configuration information of all worksheets can be obtained.</p> <p>The luckysheetfile example is as follows:</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Cell&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet name</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet color</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Worksheet index</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span> <span class="token comment">//Activation status</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span> <span class="token comment">//The order of the worksheet</span>
        <span class="token property">&quot;hide&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span><span class="token comment">//whether to hide</span>
        <span class="token property">&quot;row&quot;</span><span class="token operator">:</span> <span class="token number">36</span><span class="token punctuation">,</span> <span class="token comment">//number of rows</span>
        <span class="token property">&quot;column&quot;</span><span class="token operator">:</span> <span class="token number">18</span><span class="token punctuation">,</span> <span class="token comment">//Number of columns</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token property">&quot;merge&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//merged cells</span>
            <span class="token property">&quot;rowlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Table row height</span>
            <span class="token property">&quot;columnlen&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//Table column width</span>
            <span class="token property">&quot;rowhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//hidden rows</span>
            <span class="token property">&quot;colhidden&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//hidden columns</span>
            <span class="token property">&quot;borderInfo&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token comment">//borders</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;celldata&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//initialize the cell data</span>
        <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Update and store the cell data </span>
        <span class="token property">&quot;scrollLeft&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token comment">//Left and right scroll bar position</span>
        <span class="token property">&quot;scrollTop&quot;</span><span class="token operator">:</span> <span class="token number">315</span><span class="token punctuation">,</span> <span class="token comment">//Up and down scroll bar position</span>
        <span class="token property">&quot;luckysheet_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//selected area</span>
        <span class="token property">&quot;luckysheet_conditionformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Conditional format</span>
        <span class="token property">&quot;calcChain&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span><span class="token comment">//Formula chain</span>
        <span class="token property">&quot;isPivotTable&quot;</span><span class="token operator">:</span><span class="token boolean">false</span><span class="token punctuation">,</span><span class="token comment">//Whether to pivot table</span>
        <span class="token property">&quot;pivotTable&quot;</span><span class="token operator">:</span><span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token comment">//Pivot table configuration</span>
        <span class="token property">&quot;filter_select&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token comment">//Filter range</span>
        <span class="token property">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token null keyword">null</span><span class="token punctuation">,</span><span class="token comment">//Filter configuration</span>
        <span class="token property">&quot;luckysheet_alternateformat_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Alternate colors</span>
        <span class="token property">&quot;luckysheet_alternateformat_save_modelCustom&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Customize alternate colors</span>
        <span class="token property">&quot;chart&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//Chart configuration</span>
        <span class="token property">&quot;visibledatarow&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//The position of all rows</span>
        <span class="token property">&quot;visibledatacolumn&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span> <span class="token comment">//The position of all columns</span>
        <span class="token property">&quot;ch_width&quot;</span><span class="token operator">:</span> <span class="token number">2322</span><span class="token punctuation">,</span> <span class="token comment">//The width of the worksheet area</span>
        <span class="token property">&quot;rh_height&quot;</span><span class="token operator">:</span> <span class="token number">949</span><span class="token punctuation">,</span> <span class="token comment">//The height of the worksheet area</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet2&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token string">&quot;1&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token property">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;Sheet3&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;status&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;order&quot;</span><span class="token operator">:</span> <span class="token string">&quot;2&quot;</span><span class="token punctuation">,</span>
        <span class="token property">&quot;data&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token property">&quot;config&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token property">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">2</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div></li> <li><p><strong>Explanation</strong>：</p> <h2 id="name"><a href="#name" class="header-anchor">#</a> name</h2> <ul><li>Type：String</li> <li>Default：&quot;Sheet1&quot;</li> <li>Usage：Worksheet name</li></ul> <hr> <h2 id="color"><a href="#color" class="header-anchor">#</a> color</h2> <ul><li>Type：String</li> <li>Default：&quot;##f20e0e&quot;</li> <li>Usage：Worksheet color, there will be a bottom border under the worksheet name</li></ul> <hr> <h2 id="index"><a href="#index" class="header-anchor">#</a> index</h2> <ul><li>Type：Number</li> <li>Default：0</li> <li>Usage：Worksheet index, starting from 0</li></ul> <hr> <h2 id="status"><a href="#status" class="header-anchor">#</a> status</h2> <ul><li>Type：Number</li> <li>Default：1</li> <li>Usage：Active state, there is only one active worksheet which number will be 1 and the other worksheets are 0</li></ul> <hr> <h2 id="order"><a href="#order" class="header-anchor">#</a> order</h2> <ul><li>Type：Number</li> <li>Default：0</li> <li>Usage： The index of the worksheets is starting from 0. it will increase when a worksheet is added.</li></ul> <hr> <h2 id="hide"><a href="#hide" class="header-anchor">#</a> hide</h2> <ul><li>Type：Number</li> <li>Default：0</li> <li>Usage： Whether to hide, <code>0</code> means not to hide, <code>1</code> means to hide</li></ul> <hr> <h2 id="row"><a href="#row" class="header-anchor">#</a> row</h2> <ul><li>Type：Number</li> <li>Default：36</li> <li>Usage： The number of cell rows</li></ul> <hr> <h2 id="column"><a href="#column" class="header-anchor">#</a> column</h2> <ul><li>Type：Number</li> <li>Default：18</li> <li>Usage： The number of cell columns</li></ul> <hr> <h2 id="scrollleft"><a href="#scrollleft" class="header-anchor">#</a> scrollLeft</h2> <ul><li>Type：Number</li> <li>Default：0</li> <li>Usage： Left and right scroll bar position</li></ul> <hr> <h2 id="scrolltop"><a href="#scrolltop" class="header-anchor">#</a> scrollTop</h2> <ul><li>Type：Number</li> <li>Default：0</li> <li>Usage： Up and down scroll bar position</li></ul> <hr> <h2 id="config"><a href="#config" class="header-anchor">#</a> config</h2> <ul><li>Type: Object</li> <li>Default: {}</li> <li>Usage: Table row height, column width, merged cells, borders, hidden rows and other settings</li></ul> <h3 id="config-merge"><a href="#config-merge" class="header-anchor">#</a> config.merge</h3> <ul><li>Type：Object</li> <li>Default：{}</li> <li>Usage：Merge cell settings</li> <li>example:<div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
        <span class="token string">&quot;13_5&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">13</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">5</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">1</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;13_7&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">13</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">7</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">2</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;14_2&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">14</span><span class="token punctuation">,</span>
            <span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rs&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cs&quot;</span><span class="token operator">:</span> <span class="token number">2</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span>
</code></pre></div></li></ul> <p>The <code>key</code> in the object is the spliced value of <code>r +'_' + c</code>, and the <code>value</code> is the cell information in the upper left corner: r: number of rows, c: number of columns, rs: number of merged rows, cs: merge Number of columns</p> <h3 id="config-rowlen"><a href="#config-rowlen" class="header-anchor">#</a> config.rowlen</h3> <ul><li>Type：Object</li> <li>Default：{}</li> <li>Usage：The row height of each cell</li> <li>example:<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;rowlen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
            <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
            <span class="token string">&quot;2&quot;</span><span class="token operator">:</span> <span class="token number">20</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h3 id="config-columnlen"><a href="#config-columnlen" class="header-anchor">#</a> config.columnlen</h3> <ul><li>Type：Object</li> <li>Default：{}</li> <li>Usage：The column width of each cell</li> <li>example:<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;columnlen&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token number">97</span><span class="token punctuation">,</span>
            <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token number">115</span><span class="token punctuation">,</span>
            <span class="token string">&quot;2&quot;</span><span class="token operator">:</span> <span class="token number">128</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h3 id="config-rowhidden"><a href="#config-rowhidden" class="header-anchor">#</a> config.rowhidden</h3> <ul><li><p>Type：Object</p></li> <li><p>Default：{}</p></li> <li><p>Usage：Hidden row information, Rows：<code>rowhidden[Rows]: 0</code>,</p> <p>you should specify the number of rows by <code>key</code>,<code>value</code> is always <code>0</code></p></li> <li><p>example:</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;30&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
            <span class="token string">&quot;31&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h3 id="config-colhidden"><a href="#config-colhidden" class="header-anchor">#</a> config.colhidden</h3> <ul><li><p>Type：Object</p></li> <li><p>Default：{}</p></li> <li><p>Usage：Hidden column information, Columns：<code>colhidden[Columns]: 0</code>,</p> <p><code>key</code> specify the number of columns,<code>value</code> is always <code>0</code></p></li> <li><p>example:</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;colhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;30&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
            <span class="token string">&quot;31&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span>
</code></pre></div></li></ul> <h3 id="config-borderinfo"><a href="#config-borderinfo" class="header-anchor">#</a> config.borderInfo</h3> <ul><li>Type：Array</li> <li>Default：{}</li> <li>Usage：The border information of the cell</li> <li>example:<div class="language-js extra-class"><pre class="language-js"><code><span class="token string">&quot;borderInfo&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
                <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;cell&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;value&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                    <span class="token string">&quot;row_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;col_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;l&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;t&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
                    <span class="token punctuation">}</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;b&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                        <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                        <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
                    <span class="token punctuation">}</span>
                <span class="token punctuation">}</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;range&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;borderType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;border-all&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#0000ff&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
                    <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">7</span><span class="token punctuation">,</span> <span class="token number">8</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">]</span>
                <span class="token punctuation">}</span><span class="token punctuation">]</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;range&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;borderType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;border-inside&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#0000ff&quot;</span><span class="token punctuation">,</span>
                <span class="token string">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
                    <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">7</span><span class="token punctuation">,</span> <span class="token number">8</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
                    <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">8</span><span class="token punctuation">,</span> <span class="token number">9</span><span class="token punctuation">]</span>
                <span class="token punctuation">}</span><span class="token punctuation">]</span>
            <span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div></li></ul> <p>The range type can be divided into single cell and selected area</p> <ol><li><p>selection <code>rangeType: &quot;range&quot;</code></p> <ul><li>Border type <code>borderType：&quot;border-left&quot; | &quot;border-right&quot; | &quot;border-top&quot; | &quot;border-bottom&quot; | &quot;border-all&quot; | &quot;border-outside&quot; | &quot;border-inside&quot; | &quot;border-horizontal&quot; | &quot;border-vertical&quot; | &quot;border-none&quot;</code>,</li> <li>Border thickness <code>style: 1 Thin | 2 Hair | 3 Dotted | 4 Dashed | 5 DashDot | 6 DashDotDot | 7 Double | 8 Medium | 9 MediumDashed | 10 MediumDashDot | 11 MediumDashDotDot | 12 SlantedDashDot | 13 Thick</code></li> <li>Border color <code>color: Hexadecimal color value</code></li> <li>Selection area <code>range: Row and column information array</code></li></ul></li> <li><p>Single cell <code>rangeType：&quot;cell&quot;</code></p> <ul><li>Number of rows and columns <code>value.row_index: number,value.col_index: number</code></li> <li>Four border objects <code>value.l:Left border,value.r:Right border,value.t:Top border,value.b:Bottom border</code></li> <li>Border thickness <code>value.l.style: 1 Thin | 2 Hair | 3 Dotted | 4 Dashed | 5 DashDot | 6 DashDotDot | 7 Double | 8 Medium | 9 MediumDashed | 10 MediumDashDot | 11 MediumDashDotDot | 12 SlantedDashDot | 13 Thick</code></li> <li>Border color <code>value.l.color: Hexadecimal color value</code></li></ul></li></ol> <ul><li>示例
<ul><li><div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
    <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;range&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;borderType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;border-all&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#0000ff&quot;</span><span class="token punctuation">,</span>
    <span class="token string">&quot;range&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">7</span><span class="token punctuation">,</span> <span class="token number">8</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div><p>Represents a selection with a setting range of <code>{&quot;row&quot;: [7, 8], &quot;column&quot;: [2, 3]}</code>, the type is all borders, the border thickness is <code>Dotted</code>, and the color is <code>&quot;#0000ff&quot;</code></p></li> <li><div class="language-js extra-class"><pre class="language-js"><code> <span class="token punctuation">{</span>
        <span class="token string">&quot;rangeType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;cell&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;value&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;row_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;col_index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
            <span class="token string">&quot;l&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;t&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token string">&quot;b&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
                <span class="token string">&quot;style&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;rgb(255, 0, 0)&quot;</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">}</span>
 <span class="token punctuation">}</span>
</code></pre></div><p>Means to set the cell <code>&quot;D4&quot;</code>, the upper border/lower border/left border/right border are all border thicknesses <code>&quot;MediumDashDot&quot;</code>, color is <code>&quot;rgb(255, 0, 0)&quot;</code></p></li></ul></li></ul> <hr> <h2 id="celldata"><a href="#celldata" class="header-anchor">#</a> celldata</h2> <ul><li>Type：Array</li> <li>Default：[]</li> <li>Usage： The original cell data set is a set containing <code>{r:0,c:0,v:{m:&quot;value&quot;,v:&quot;value&quot;,ct: {fa: &quot;General&quot;, t: &quot;g&quot;}} }</code>The one-dimensional array of format cell information is only used during initialization. After the table is initialized with celldata, the data is converted to the same level field data in the luckysheetfile, such as <code>luckysheetfile[0].data</code>, the subsequent operation of the table Data update will be updated to this data field, and celldata is no longer used. Example:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
	<span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
	<span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
	<span class="token string">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
		m<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span><span class="token punctuation">,</span>
		v<span class="token operator">:</span><span class="token string">&quot;value1&quot;</span>
	<span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
	<span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
	<span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
	<span class="token string">&quot;v&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		ct<span class="token operator">:</span> <span class="token punctuation">{</span>fa<span class="token operator">:</span> <span class="token string">&quot;General&quot;</span><span class="token punctuation">,</span> t<span class="token operator">:</span> <span class="token string">&quot;g&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
		m<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span><span class="token punctuation">,</span>
		v<span class="token operator">:</span><span class="token string">&quot;value2&quot;</span>
	<span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div><hr> <h2 id="luckysheet-select-save"><a href="#luckysheet-select-save" class="header-anchor">#</a> luckysheet_select_save</h2> <ul><li>Type：Array</li> <li>Default：[]</li> <li>Usage： The selected area supports multiple selections and is a one-dimensional array containing multiple selection objects. Example:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token string">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">97</span><span class="token punctuation">,</span>
        <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token string">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
        <span class="token string">&quot;left_move&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token string">&quot;width_move&quot;</span><span class="token operator">:</span> <span class="token number">97</span><span class="token punctuation">,</span>
        <span class="token string">&quot;top_move&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token string">&quot;height_move&quot;</span><span class="token operator">:</span> <span class="token number">41</span><span class="token punctuation">,</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">1</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">0</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;row_focus&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column_focus&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">98</span><span class="token punctuation">,</span>
        <span class="token string">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">73</span><span class="token punctuation">,</span>
        <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">63</span><span class="token punctuation">,</span>
        <span class="token string">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
        <span class="token string">&quot;left_move&quot;</span><span class="token operator">:</span> <span class="token number">98</span><span class="token punctuation">,</span>
        <span class="token string">&quot;width_move&quot;</span><span class="token operator">:</span> <span class="token number">189</span><span class="token punctuation">,</span>
        <span class="token string">&quot;top_move&quot;</span><span class="token operator">:</span> <span class="token number">63</span><span class="token punctuation">,</span>
        <span class="token string">&quot;height_move&quot;</span><span class="token operator">:</span> <span class="token number">41</span><span class="token punctuation">,</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;row_focus&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column_focus&quot;</span><span class="token operator">:</span> <span class="token number">1</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">288</span><span class="token punctuation">,</span>
        <span class="token string">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">128</span><span class="token punctuation">,</span>
        <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">21</span><span class="token punctuation">,</span>
        <span class="token string">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
        <span class="token string">&quot;left_move&quot;</span><span class="token operator">:</span> <span class="token number">288</span><span class="token punctuation">,</span>
        <span class="token string">&quot;width_move&quot;</span><span class="token operator">:</span> <span class="token number">128</span><span class="token punctuation">,</span>
        <span class="token string">&quot;top_move&quot;</span><span class="token operator">:</span> <span class="token number">21</span><span class="token punctuation">,</span>
        <span class="token string">&quot;height_move&quot;</span><span class="token operator">:</span> <span class="token number">62</span><span class="token punctuation">,</span>
        <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;row_focus&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;column_focus&quot;</span><span class="token operator">:</span> <span class="token number">3</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div><hr> <h2 id="luckysheet-conditionformat-save"><a href="#luckysheet-conditionformat-save" class="header-anchor">#</a> luckysheet_conditionformat_save</h2> <ul><li>Type：Array</li> <li>Default：[]</li> <li>Usage： Conditional format configuration information, a one-dimensional array containing multiple conditional format configuration objects,</li></ul> <p>type: &quot;default&quot;: Highlight cell rules and project selection rules,</p> <p>&quot;dataBar&quot;: Data bar,</p> <p>&quot;icons&quot;: Icon set,</p> <p>&quot;colorGradation&quot;: Color scale</p> <p>Example:</p> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;default&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">7</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;textColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000000&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;cellColor&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ff0000&quot;</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;conditionName&quot;</span><span class="token operator">:</span> <span class="token string">&quot;betweenness&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;conditionRange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">4</span><span class="token punctuation">,</span> <span class="token number">4</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span><span class="token punctuation">,</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;conditionValue&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">4</span>
        <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;dataBar&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">15</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">11</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token string">&quot;#6aa84f&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;#ffffff&quot;</span>
        <span class="token punctuation">]</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;icons&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">19</span><span class="token punctuation">,</span> <span class="token number">23</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">2</span><span class="token punctuation">,</span> <span class="token number">2</span> <span class="token punctuation">]</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;len&quot;</span><span class="token operator">:</span> <span class="token string">&quot;3&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;leftMin&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token string">&quot;0&quot;</span>
        <span class="token punctuation">}</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token punctuation">{</span>
        <span class="token string">&quot;type&quot;</span><span class="token operator">:</span> <span class="token string">&quot;colorGradation&quot;</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token punctuation">{</span>
                <span class="token string">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">422</span><span class="token punctuation">,</span>
                <span class="token string">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">100</span><span class="token punctuation">,</span>
                <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">210</span><span class="token punctuation">,</span>
                <span class="token string">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">20</span><span class="token punctuation">,</span>
                <span class="token string">&quot;left_move&quot;</span><span class="token operator">:</span> <span class="token number">422</span><span class="token punctuation">,</span>
                <span class="token string">&quot;width_move&quot;</span><span class="token operator">:</span> <span class="token number">100</span><span class="token punctuation">,</span>
                <span class="token string">&quot;top_move&quot;</span><span class="token operator">:</span> <span class="token number">210</span><span class="token punctuation">,</span>
                <span class="token string">&quot;height_move&quot;</span><span class="token operator">:</span> <span class="token number">125</span><span class="token punctuation">,</span>
                <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">10</span><span class="token punctuation">,</span> <span class="token number">15</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token number">6</span> <span class="token punctuation">]</span><span class="token punctuation">,</span>
                <span class="token string">&quot;row_focus&quot;</span><span class="token operator">:</span> <span class="token number">10</span><span class="token punctuation">,</span>
                <span class="token string">&quot;column_focus&quot;</span><span class="token operator">:</span> <span class="token number">6</span>
            <span class="token punctuation">}</span>
        <span class="token punctuation">]</span><span class="token punctuation">,</span>
        <span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
            <span class="token string">&quot;rgb(99, 190, 123)&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rgb(255, 235, 132)&quot;</span><span class="token punctuation">,</span>
            <span class="token string">&quot;rgb(248, 105, 107)&quot;</span>
        <span class="token punctuation">]</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">]</span>
</code></pre></div><hr> <h2 id="calcchain"><a href="#calcchain" class="header-anchor">#</a> calcChain</h2> <ul><li>Type：Array</li> <li>Default：[]</li> <li>Usage：Formula chain, used when the cell linked by the formula is changed, all formulas referencing this cell will be refreshed, example:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
	<span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span>
	<span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
	<span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
	<span class="token string">&quot;func&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token number">23.75</span><span class="token punctuation">,</span> <span class="token string">&quot;=AVERAGE(D3:D6)&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
	<span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;w&quot;</span><span class="token punctuation">,</span>
	<span class="token string">&quot;parent&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span>
	<span class="token string">&quot;chidren&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;times&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
	<span class="token string">&quot;r&quot;</span><span class="token operator">:</span> <span class="token number">7</span><span class="token punctuation">,</span>
	<span class="token string">&quot;c&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
	<span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
	<span class="token string">&quot;func&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token boolean">true</span><span class="token punctuation">,</span> <span class="token number">30</span><span class="token punctuation">,</span> <span class="token string">&quot;=MAX(D3:D6)&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
	<span class="token string">&quot;color&quot;</span><span class="token operator">:</span> <span class="token string">&quot;w&quot;</span><span class="token punctuation">,</span>
	<span class="token string">&quot;parent&quot;</span><span class="token operator">:</span> <span class="token keyword">null</span><span class="token punctuation">,</span>
	<span class="token string">&quot;chidren&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;times&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div><hr> <h2 id="ispivottable"><a href="#ispivottable" class="header-anchor">#</a> isPivotTable</h2> <ul><li>Type：Boolean</li> <li>Default：false</li> <li>Usage： Whether PivotTable</li></ul> <hr> <h2 id="pivottable"><a href="#pivottable" class="header-anchor">#</a> pivotTable</h2> <ul><li>Type：Object</li> <li>Default：{}</li> <li>Usage： Pivot table settings, example:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
	<span class="token string">&quot;pivot_select_save&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
		<span class="token string">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">73</span><span class="token punctuation">,</span>
		<span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
		<span class="token string">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">19</span><span class="token punctuation">,</span>
		<span class="token string">&quot;left_move&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
		<span class="token string">&quot;width_move&quot;</span><span class="token operator">:</span> <span class="token number">369</span><span class="token punctuation">,</span>
		<span class="token string">&quot;top_move&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
		<span class="token string">&quot;height_move&quot;</span><span class="token operator">:</span> <span class="token number">259</span><span class="token punctuation">,</span>
		<span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">0</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token string">&quot;row_focus&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
		<span class="token string">&quot;column_focus&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;pivotDataSheetIndex&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span> <span class="token comment">//The sheet index where the source data is located</span>
	<span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
		<span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">3</span><span class="token punctuation">,</span>
		<span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;subject&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;subject&quot;</span>
	<span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
	<span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
		<span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
		<span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;student&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;student&quot;</span>
	<span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
	<span class="token string">&quot;filter&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
	<span class="token string">&quot;values&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token punctuation">{</span>
		<span class="token string">&quot;index&quot;</span><span class="token operator">:</span> <span class="token number">4</span><span class="token punctuation">,</span>
		<span class="token string">&quot;name&quot;</span><span class="token operator">:</span> <span class="token string">&quot;score&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;fullname&quot;</span><span class="token operator">:</span> <span class="token string">&quot;count:score&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;sumtype&quot;</span><span class="token operator">:</span> <span class="token string">&quot;COUNTA&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;nameindex&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
	<span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
	<span class="token string">&quot;showType&quot;</span><span class="token operator">:</span> <span class="token string">&quot;column&quot;</span><span class="token punctuation">,</span>
	<span class="token string">&quot;pivotDatas&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
		<span class="token punctuation">[</span><span class="token string">&quot;count:score&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;science&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;mathematics&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;foreign language&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;English&quot;</span><span class="token punctuation">,</span> <span class="token string">&quot;total&quot;</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token punctuation">[</span><span class="token string">&quot;Alex&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token punctuation">[</span><span class="token string">&quot;Joy&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token punctuation">[</span><span class="token string">&quot;Tim&quot;</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">4</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token punctuation">[</span><span class="token string">&quot;total&quot;</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">3</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span>
	<span class="token punctuation">]</span><span class="token punctuation">,</span>
	<span class="token string">&quot;drawPivotTable&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
	<span class="token string">&quot;pivotTableBoundary&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">5</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div><hr> <h2 id="filter-select"><a href="#filter-select" class="header-anchor">#</a> filter_select</h2> <ul><li>Type：Object</li> <li>Default：{}</li> <li>Usage：Filter range, a selection area, a sheet has only one filter range, similar to the <code>luckysheet_select_save</code> example:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
    <span class="token string">&quot;left&quot;</span><span class="token operator">:</span> <span class="token number">74</span><span class="token punctuation">,</span>
    <span class="token string">&quot;width&quot;</span><span class="token operator">:</span> <span class="token number">73</span><span class="token punctuation">,</span>
    <span class="token string">&quot;top&quot;</span><span class="token operator">:</span> <span class="token number">40</span><span class="token punctuation">,</span>
    <span class="token string">&quot;height&quot;</span><span class="token operator">:</span> <span class="token number">19</span><span class="token punctuation">,</span>
    <span class="token string">&quot;left_move&quot;</span><span class="token operator">:</span> <span class="token number">74</span><span class="token punctuation">,</span>
    <span class="token string">&quot;width_move&quot;</span><span class="token operator">:</span> <span class="token number">221</span><span class="token punctuation">,</span>
    <span class="token string">&quot;top_move&quot;</span><span class="token operator">:</span> <span class="token number">40</span><span class="token punctuation">,</span>
    <span class="token string">&quot;height_move&quot;</span><span class="token operator">:</span> <span class="token number">99</span><span class="token punctuation">,</span>
    <span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
        <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token number">6</span>
    <span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span>
        <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token number">3</span>
    <span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token string">&quot;row_focus&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
    <span class="token string">&quot;column_focus&quot;</span><span class="token operator">:</span> <span class="token number">1</span>
<span class="token punctuation">}</span>
</code></pre></div><hr> <h2 id="filter"><a href="#filter" class="header-anchor">#</a> filter</h2> <ul><li>Type：Object</li> <li>Default：{}</li> <li>Usage： Specific settings for filtering, examples:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">{</span>
    <span class="token string">&quot;0&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;caljs&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;3&quot;</span><span class="token operator">:</span> <span class="token number">0</span><span class="token punctuation">,</span>
            <span class="token string">&quot;4&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;optionstate&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        <span class="token string">&quot;str&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edr&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cindex&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;stc&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edc&quot;</span><span class="token operator">:</span> <span class="token number">3</span>
    <span class="token punctuation">}</span><span class="token punctuation">,</span>
    <span class="token string">&quot;1&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
        <span class="token string">&quot;caljs&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span><span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;rowhidden&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
            <span class="token string">&quot;6&quot;</span><span class="token operator">:</span> <span class="token number">0</span>
        <span class="token punctuation">}</span><span class="token punctuation">,</span>
        <span class="token string">&quot;optionstate&quot;</span><span class="token operator">:</span> <span class="token boolean">true</span><span class="token punctuation">,</span>
        <span class="token string">&quot;str&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edr&quot;</span><span class="token operator">:</span> <span class="token number">6</span><span class="token punctuation">,</span>
        <span class="token string">&quot;cindex&quot;</span><span class="token operator">:</span> <span class="token number">2</span><span class="token punctuation">,</span>
        <span class="token string">&quot;stc&quot;</span><span class="token operator">:</span> <span class="token number">1</span><span class="token punctuation">,</span>
        <span class="token string">&quot;edc&quot;</span><span class="token operator">:</span> <span class="token number">3</span>
    <span class="token punctuation">}</span>
<span class="token punctuation">}</span>
</code></pre></div><hr> <h2 id="luckysheet-alternateformat-save"><a href="#luckysheet-alternateformat-save" class="header-anchor">#</a> luckysheet_alternateformat_save</h2> <ul><li>Type：Array</li> <li>Default：[]</li> <li>Usage： Alternating color configuration, example:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
	<span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">5</span><span class="token punctuation">]</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#5ed593&quot;</span>
		<span class="token punctuation">}</span><span class="token punctuation">,</span>
		<span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
		<span class="token punctuation">}</span><span class="token punctuation">,</span>
		<span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#e5fbee&quot;</span>
		<span class="token punctuation">}</span><span class="token punctuation">,</span>
		<span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#a5efcc&quot;</span>
		<span class="token punctuation">}</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;hasRowHeader&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
	<span class="token string">&quot;hasRowFooter&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span>
<span class="token punctuation">}</span><span class="token punctuation">,</span> <span class="token punctuation">{</span>
	<span class="token string">&quot;cellrange&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;row&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token number">6</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
		<span class="token string">&quot;column&quot;</span><span class="token operator">:</span> <span class="token punctuation">[</span><span class="token number">8</span><span class="token punctuation">,</span> <span class="token number">12</span><span class="token punctuation">]</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;format&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#5599fc&quot;</span>
		<span class="token punctuation">}</span><span class="token punctuation">,</span>
		<span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
		<span class="token punctuation">}</span><span class="token punctuation">,</span>
		<span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ecf2fe&quot;</span>
		<span class="token punctuation">}</span><span class="token punctuation">,</span>
		<span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
			<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
			<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#afcbfa&quot;</span>
		<span class="token punctuation">}</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;hasRowHeader&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span>
	<span class="token string">&quot;hasRowFooter&quot;</span><span class="token operator">:</span> <span class="token boolean">false</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div><hr> <h2 id="luckysheet-alternateformat-save-modelcustom"><a href="#luckysheet-alternateformat-save-modelcustom" class="header-anchor">#</a> luckysheet_alternateformat_save_modelCustom</h2> <ul><li>Type：Array</li> <li>Default：[]</li> <li>Usage：Custom alternate colors, including multiple custom alternate colors configuration, example:</li></ul> <div class="language-js extra-class"><pre class="language-js"><code><span class="token punctuation">[</span><span class="token punctuation">{</span>
	<span class="token string">&quot;head&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#6aa84f&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;one&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#ffffff&quot;</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;two&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#e5fbee&quot;</span>
	<span class="token punctuation">}</span><span class="token punctuation">,</span>
	<span class="token string">&quot;foot&quot;</span><span class="token operator">:</span> <span class="token punctuation">{</span>
		<span class="token string">&quot;fc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#000&quot;</span><span class="token punctuation">,</span>
		<span class="token string">&quot;bc&quot;</span><span class="token operator">:</span> <span class="token string">&quot;#a5efcc&quot;</span>
	<span class="token punctuation">}</span>
<span class="token punctuation">}</span><span class="token punctuation">]</span>
</code></pre></div><hr> <h2 id="chart"><a href="#chart" class="header-anchor">#</a> chart</h2> <ul><li>Type：Array</li> <li>Default：[]</li> <li>Usage： Chart configuration (under development)</li></ul> <hr> <h2 id="visibledatarow"><a href="#visibledatarow" class="header-anchor">#</a> visibledatarow</h2> <ul><li>Type：Number</li> <li>Default：[]</li> <li>Usage： Position information of all rows, incremental row position data, No need to set up for initialization</li></ul> <hr> <h2 id="visibledatacolumn"><a href="#visibledatacolumn" class="header-anchor">#</a> visibledatacolumn</h2> <ul><li>Type：Number</li> <li>Default：[]</li> <li>Usage： Position information of all columns, incremental column position data, No need to set up for initialization</li></ul> <hr> <h2 id="ch-width"><a href="#ch-width" class="header-anchor">#</a> ch_width</h2> <ul><li>Type：Number</li> <li>Default：2322</li> <li>Usage：The width of the entire worksheet area (the gray area including the border), No need to set up for initialization</li></ul> <hr> <h2 id="rh-height"><a href="#rh-height" class="header-anchor">#</a> rh_height</h2> <ul><li>Type：Number</li> <li>Default：2322</li> <li>Usage：The height of the entire worksheet area (the gray area containing the border), No need to set up for initialization</li></ul> <hr></li></ul> <h2 id="get-sheet-data"><a href="#get-sheet-data" class="header-anchor">#</a> Get sheet data</h2> <ul><li><p><strong>Configuration</strong>：</p> <p>Configure the address of <code>loadSheetUrl</code>, the parameters are <code>gridKey</code> (table primary key) and <code>index</code> (sheet primary key collection, format is <code>[1,2,3]</code>), the returned data is the <code>data</code> field set of sheet</p></li> <li><p><strong>Format</strong>：</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    <span class="token property">&quot;1&quot;</span><span class="token operator">:</span>  <span class="token punctuation">[</span><span class="token punctuation">{</span>r<span class="token operator">:</span><span class="token number">0</span><span class="token punctuation">,</span> c<span class="token operator">:</span><span class="token number">1</span><span class="token punctuation">,</span> v<span class="token operator">:</span><span class="token string">&quot;value 1&quot;</span><span class="token punctuation">}</span><span class="token punctuation">,</span><span class="token punctuation">{</span>r<span class="token operator">:</span><span class="token number">10</span><span class="token punctuation">,</span> c<span class="token operator">:</span><span class="token number">11</span><span class="token punctuation">,</span> v<span class="token operator">:</span><span class="token string">&quot;value 2&quot;</span><span class="token punctuation">}</span><span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token property">&quot;2&quot;</span><span class="token operator">:</span>  <span class="token punctuation">[</span>data<span class="token punctuation">]</span><span class="token punctuation">,</span>
    <span class="token property">&quot;3&quot;</span><span class="token operator">:</span>  <span class="token punctuation">[</span>data<span class="token punctuation">]</span><span class="token punctuation">,</span>
<span class="token punctuation">}</span>
</code></pre></div></li> <li><p><strong>Explanation</strong>：</p> <p><code>r</code> stands for row, <code>c</code> stands for column, and <code>v</code> stands for the value of the cell. The value can be a character, number, or json string.</p> <p>The data will only be loaded once, generally speaking, there is only one primary key, but considering that some formulas, charts and pivot tables will refer to the data of other sheets, the front desk will add a judgment, if the current sheet refers to the data of other sheets, then complete the data of the referenced sheet together.</p></li></ul> <h2 id="update-data"><a href="#update-data" class="header-anchor">#</a> Update data</h2> <ul><li><p><strong>Configuration</strong>：</p> <p>Configure the address of <code>updateUrl</code>, and the parameter sent to the backend is a json string.</p></li> <li><p><strong>Format</strong>：</p> <div class="language-json extra-class"><pre class="language-json"><code><span class="token punctuation">{</span>
    compress<span class="token operator">:</span> <span class="token boolean">false</span><span class="token punctuation">,</span> 
    gridKey<span class="token operator">:</span><span class="token number">10004</span><span class="token punctuation">,</span>
    data<span class="token operator">:</span> <span class="token punctuation">[</span>update data<span class="token punctuation">]</span>
<span class="token punctuation">}</span>
</code></pre></div></li> <li><p><strong>Explanation</strong>：</p> <table><thead><tr><th>Parameter</th> <th>Explanation</th> <th>Example</th></tr></thead> <tbody><tr><td>compress</td> <td>Luckysheet uses client pako for zlib parameter compression, which is true if the browser supports compression, otherwise false. The backend can decide whether to decompress the data content based on this parameter</td> <td>The process of obtaining parameters on the server side: 1. Serialize json string 2. Decode the data field if the compress field is TRUE 3. Decode the data string URLDecoder.decode(utf-8)</td></tr> <tr><td>gridKey</td> <td>Luckysheet file identifier</td> <td>none</td></tr> <tr><td>data</td> <td>An array containing updated data. For the parameter format in the array, please see the introduction below. In the example: <code>t</code> indicates the update type, <code>i</code> is the index of the sheet, <code>c</code> is the row number, <code>r</code> is the column number, and <code>v</code> is the value</td> <td><code>data: [{ t : 'cell', i:0, c : 0, r : 0 , v: 2 }]</code></td></tr></tbody></table></li></ul></div> <footer class="page-edit"><div class="edit-link"><a href="https://github.com/mengshukeji/Luckysheet/edit/master/docs/guide/data.md" target="_blank" rel="noopener noreferrer">Edit this page on GitHub</a> <span><svg xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewBox="0 0 100 100" width="15" height="15" class="icon outbound"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path> <polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg> <span class="sr-only">(opens new window)</span></span></div> <div class="last-updated"><span class="prefix">Last Updated:</span> <span class="time">1/19/2021, 1:33:53 AM</span></div></footer> <!----> </main></div><div class="global-ui"></div></div>
    <script src="/LuckysheetDocs/assets/js/app.02d9598d.js" defer></script><script src="/LuckysheetDocs/assets/js/2.daa13025.js" defer></script><script src="/LuckysheetDocs/assets/js/17.e9ae302c.js" defer></script>
  </body>
</html>
